package com.ruoyi.product.mapper;

import com.ruoyi.product.domain.Count;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface CountMapper {
    @Select("select pc.name,count(b.product_classify) 'count' from product_category pc left join basic b on b.product_classify=pc.name \n" +
            "where pc.parent_id>0 GROUP BY pc.id ")
    List<Count> selectList();

}
